﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Spread.Master" AutoEventWireup="true" CodeBehind="Overview.aspx.cs" Inherits="ControlExplorer.samples.RowEditTemplate.Overview" %>
<%@ Register Assembly="FarPoint.Web.Spread"
    Namespace="FarPoint.Web.Spread" TagPrefix="FarPoint" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Head" runat="server">
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
  <asp:Menu ID="Menu1" runat="server" StaticSubMenuIndent="20px" Orientation="Horizontal" OnMenuItemClick="Menu1_MenuItemClick" ForeColor="#7C6F57" Font-Size="1em" Font-Names="Verdana" DynamicHorizontalOffset="20" BorderWidth="1px" BorderStyle="Solid" BorderColor="Gray" BackColor="#F7F6F3">
    <StaticMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
    <DynamicHoverStyle BackColor="#7C6F57" ForeColor="White" />
    <DynamicMenuStyle BackColor="#F7F6F3" BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px" />
    <DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" />
    <StaticHoverStyle BackColor="#7C6F57" ForeColor="White" />
    <Items>
      <asp:MenuItem ImageUrl="../images/logviewer.png" Selectable="False" Text="编辑模式"
        Value="Print to PDF">
        <asp:MenuItem ImageUrl="../images/gnome-util.png" Text="启用行编辑模式和客户端脚本。(开启编辑模板)"
          Value="0"></asp:MenuItem>
        <asp:MenuItem ImageUrl="../images/gnome-util.png" Text="禁用客户端脚本(开启编辑模板)"
          Value="1"></asp:MenuItem>
        <asp:MenuItem ImageUrl="../images/gnome-util.png" Text="启用普通编辑模式和客户端脚本(禁用编辑模板)"
          Value="2"></asp:MenuItem>
      </asp:MenuItem>
    </Items>
  </asp:Menu>
  <br />
  <br />
  <div style="position: relative; width: 780px; height: 380px; overflow: hidden">
    <FarPoint:FpSpread ID="FpSpread1" runat="server" BorderColor="Black" BorderStyle="Solid"
      BorderWidth="1px" Height="360px" Width="770px" ActiveSheetViewIndex="0" 
          DesignString='<?xml version="1.0" encoding="utf-8"?><Spread />' 
          currentPageIndex="0">
      <CommandBar BackColor="Transparent">
        <Background BackgroundImageUrl="SPREADCLIENTPATH:/img/cbbg.gif" />
      </CommandBar>
      <Sheets>
        <FarPoint:SheetView SheetName="Sheet1" AllowDelete="True" AllowInsert="True" 
              DesignString="&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;Sheet&gt;&lt;Data&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;7&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;5&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;Cells&gt;&lt;Cell row=&quot;0&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;书号&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;书名&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;价格&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;直销&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;所有者&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;7&quot; columns=&quot;5&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;SheetName&gt;Sheet1&lt;/SheetName&gt;&lt;Cells&gt;&lt;Cell row=&quot;0&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;N001&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Dynamic HTML&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;20&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Owen&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;N002&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;CSS Mastery&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Decimal&quot;&gt;30&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;0&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Winnow&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;2&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;N003&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;2&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;JavaScript Ref&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;2&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Decimal&quot;&gt;40&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;2&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;0&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;2&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Venture&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;3&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;N004&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;3&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;ASP.NET 2.0&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;3&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Decimal&quot;&gt;25&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;3&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;3&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Lucky&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;4&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;N005&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;4&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Programing Windows&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;4&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Decimal&quot;&gt;27&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;4&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;4&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Owen&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;5&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;N006&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;5&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Thinking C++&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;5&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Decimal&quot;&gt;16&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;5&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;5&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Owen&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;6&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;N007&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;6&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;National Geographic&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;6&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Decimal&quot;&gt;10&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;6&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;6&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;Owen&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;5&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/ColumnFooter&gt;&lt;/Data&gt;&lt;Presentation&gt;&lt;ActiveSkin class=&quot;FarPoint.Web.Spread.SheetSkin&quot;&gt;&lt;Name&gt;Default&lt;/Name&gt;&lt;BackColor&gt;Empty&lt;/BackColor&gt;&lt;CellBackColor&gt;Empty&lt;/CellBackColor&gt;&lt;CellForeColor&gt;Empty&lt;/CellForeColor&gt;&lt;CellSpacing&gt;0&lt;/CellSpacing&gt;&lt;GridLines&gt;Both&lt;/GridLines&gt;&lt;GridLineColor&gt;#d0d7e5&lt;/GridLineColor&gt;&lt;HeaderBackColor&gt;Empty&lt;/HeaderBackColor&gt;&lt;HeaderForeColor&gt;Empty&lt;/HeaderForeColor&gt;&lt;FlatColumnHeader&gt;False&lt;/FlatColumnHeader&gt;&lt;FooterBackColor&gt;Empty&lt;/FooterBackColor&gt;&lt;FooterForeColor&gt;Empty&lt;/FooterForeColor&gt;&lt;FlatColumnFooter&gt;False&lt;/FlatColumnFooter&gt;&lt;FlatRowHeader&gt;False&lt;/FlatRowHeader&gt;&lt;HeaderFontBold&gt;False&lt;/HeaderFontBold&gt;&lt;FooterFontBold&gt;False&lt;/FooterFontBold&gt;&lt;SelectionBackColor&gt;#eaecf5&lt;/SelectionBackColor&gt;&lt;SelectionForeColor&gt;Empty&lt;/SelectionForeColor&gt;&lt;EvenRowBackColor&gt;Empty&lt;/EvenRowBackColor&gt;&lt;OddRowBackColor&gt;Empty&lt;/OddRowBackColor&gt;&lt;ShowColumnHeader&gt;True&lt;/ShowColumnHeader&gt;&lt;ShowColumnFooter&gt;False&lt;/ShowColumnFooter&gt;&lt;ShowRowHeader&gt;True&lt;/ShowRowHeader&gt;&lt;ColumnHeaderBackground class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/ColumnHeaderBackground&gt;&lt;SheetCornerBackground class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/SheetCornerBackground&gt;&lt;HeaderGrayAreaColor&gt;#7999c2&lt;/HeaderGrayAreaColor&gt;&lt;FilterBarBackColor&gt;#e7eff7&lt;/FilterBarBackColor&gt;&lt;FilterBarForeColor&gt;Empty&lt;/FilterBarForeColor&gt;&lt;FilterBarHeaderBackColor&gt;#e7eff7&lt;/FilterBarHeaderBackColor&gt;&lt;FilterBarHeaderForeColor&gt;Empty&lt;/FilterBarHeaderForeColor&gt;&lt;ShowFilterBar&gt;False&lt;/ShowFilterBar&gt;&lt;FilterBarHeaderParent&gt;RowHeaderDefault&lt;/FilterBarHeaderParent&gt;&lt;FilterBarParent&gt;FilterBarDefault&lt;/FilterBarParent&gt;&lt;/ActiveSkin&gt;&lt;AxisModels&gt;&lt;Row class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;7&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/Row&gt;&lt;Column class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;90&quot; orientation=&quot;Horizontal&quot; count=&quot;5&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;Size&gt;90&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;1&quot;&gt;&lt;Size&gt;150&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;2&quot;&gt;&lt;Size&gt;90&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/Column&gt;&lt;RowHeaderColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;40&quot; orientation=&quot;Horizontal&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;Size&gt;40&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RowHeaderColumn&gt;&lt;ColumnHeaderRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnHeaderRow&gt;&lt;ColumnFooterRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Horizontal&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnFooterRow&gt;&lt;/AxisModels&gt;&lt;StyleModels&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;7&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;RowHeaderDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;5&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;ColumnHeaderDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/DefaultStyle&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;7&quot; Columns=&quot;5&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;DataAreaDefault&quot; /&gt;&lt;ColumnStyles&gt;&lt;ColumnStyle Index=&quot;2&quot;&gt;&lt;CellType class=&quot;FarPoint.Web.Spread.CurrencyCellType&quot;&gt;&lt;ErrorMsg&gt;Currency: (ex, 1234.56)&lt;/ErrorMsg&gt;&lt;AllowWrap&gt;False&lt;/AllowWrap&gt;&lt;IsDateFormat&gt;False&lt;/IsDateFormat&gt;&lt;GeneralCellType /&gt;&lt;CurrencyCellType /&gt;&lt;/CellType&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;3&quot;&gt;&lt;CellType class=&quot;FarPoint.Web.Spread.CheckBoxCellType&quot; /&gt;&lt;HorizontalAlign&gt;Center&lt;/HorizontalAlign&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;4&quot;&gt;&lt;CellType class=&quot;FarPoint.Web.Spread.ComboBoxCellType&quot;&gt;&lt;Items&gt;&lt;Item text=&quot;Owen&quot; value=&quot;Owen&quot; /&gt;&lt;Item text=&quot;Winnow&quot; value=&quot;Winnow&quot; /&gt;&lt;Item text=&quot;Venture&quot; value=&quot;Venture&quot; /&gt;&lt;Item text=&quot;Lucky&quot; value=&quot;Lucky&quot; /&gt;&lt;/Items&gt;&lt;/CellType&gt;&lt;Locked&gt;False&lt;/Locked&gt;&lt;/ColumnStyle&gt;&lt;/ColumnStyles&gt;&lt;ConditionalFormatCollections /&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/DefaultStyle&gt;&lt;ConditionalFormatCollections /&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;5&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnFooter&gt;&lt;/StyleModels&gt;&lt;MessageRowStyle class=&quot;FarPoint.Web.Spread.Appearance&quot;&gt;&lt;BackColor&gt;LightYellow&lt;/BackColor&gt;&lt;ForeColor&gt;Red&lt;/ForeColor&gt;&lt;/MessageRowStyle&gt;&lt;SheetCornerStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/SheetCornerStyle&gt;&lt;AllowLoadOnDemand&gt;false&lt;/AllowLoadOnDemand&gt;&lt;LoadRowIncrement &gt;10&lt;/LoadRowIncrement &gt;&lt;LoadInitRowCount &gt;30&lt;/LoadInitRowCount &gt;&lt;LoadOnDemandMode &gt;Standard&lt;/LoadOnDemandMode &gt;&lt;LoadOnDemandInterval &gt;500&lt;/LoadOnDemandInterval &gt;&lt;LoadOnDemandTriggerMode &gt;Timed&lt;/LoadOnDemandTriggerMode &gt;&lt;LoadOffsetFromBottom &gt;0&lt;/LoadOffsetFromBottom &gt;&lt;AllowVirtualScrollPaging&gt;false&lt;/AllowVirtualScrollPaging&gt;&lt;VirtualScrollPagingPrevRowCount&gt;0&lt;/VirtualScrollPagingPrevRowCount&gt;&lt;VirtualScrollPagingFormatString&gt;Page {page} of {count}&lt;/VirtualScrollPagingFormatString&gt;&lt;TopRow&gt;0&lt;/TopRow&gt;&lt;PreviewRowStyle class=&quot;FarPoint.Web.Spread.PreviewRowInfo&quot; /&gt;&lt;FilterBar class=&quot;FarPoint.Web.Spread.FilterBar&quot;&gt;&lt;Height&gt;22&lt;/Height&gt;&lt;IndicatorCssClass /&gt;&lt;Style class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;2&quot; Columns=&quot;5&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;RowStyles&gt;&lt;RowStyle Index=&quot;0&quot; class=&quot;FarPoint.Web.Spread.FilterBarStyleInfo&quot; Parent=&quot;FilterBarDefault&quot; /&gt;&lt;RowStyle Index=&quot;1&quot; class=&quot;FarPoint.Web.Spread.FilterBarStyleInfo&quot; Parent=&quot;RowHeaderDefault&quot;&gt;&lt;HorizontalAlign&gt;Center&lt;/HorizontalAlign&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/RowStyle&gt;&lt;/RowStyles&gt;&lt;ConditionalFormatCollections /&gt;&lt;/Style&gt;&lt;/FilterBar&gt;&lt;/Presentation&gt;&lt;Settings&gt;&lt;Name&gt;Sheet1&lt;/Name&gt;&lt;Categories&gt;&lt;Appearance&gt;&lt;GridLineColor&gt;#d0d7e5&lt;/GridLineColor&gt;&lt;SelectionBackColor&gt;#eaecf5&lt;/SelectionBackColor&gt;&lt;SelectionBorder class=&quot;FarPoint.Web.Spread.Border&quot; /&gt;&lt;/Appearance&gt;&lt;Behavior&gt;&lt;EnableRowEditTemplate&gt;True&lt;/EnableRowEditTemplate&gt;&lt;EditTemplateColumnCount&gt;2&lt;/EditTemplateColumnCount&gt;&lt;GroupBarText&gt;Drag a column to group by that column.&lt;/GroupBarText&gt;&lt;AllowDelete&gt;True&lt;/AllowDelete&gt;&lt;AllowInsert&gt;True&lt;/AllowInsert&gt;&lt;/Behavior&gt;&lt;Layout&gt;&lt;ColumnCount&gt;5&lt;/ColumnCount&gt;&lt;RowCount&gt;7&lt;/RowCount&gt;&lt;ColumnHeaderRowCount&gt;1&lt;/ColumnHeaderRowCount&gt;&lt;RowHeaderColumnCount&gt;1&lt;/RowHeaderColumnCount&gt;&lt;/Layout&gt;&lt;/Categories&gt;&lt;ActiveRow&gt;0&lt;/ActiveRow&gt;&lt;ActiveColumn&gt;0&lt;/ActiveColumn&gt;&lt;ColumnHeaderRowCount&gt;1&lt;/ColumnHeaderRowCount&gt;&lt;ColumnFooterRowCount&gt;1&lt;/ColumnFooterRowCount&gt;&lt;PrintInfo&gt;&lt;Header /&gt;&lt;Footer /&gt;&lt;ZoomFactor&gt;1&lt;/ZoomFactor&gt;&lt;FirstPageNumber&gt;1&lt;/FirstPageNumber&gt;&lt;Orientation&gt;Auto&lt;/Orientation&gt;&lt;PrintType&gt;All&lt;/PrintType&gt;&lt;PageOrder&gt;Auto&lt;/PageOrder&gt;&lt;BestFitCols&gt;False&lt;/BestFitCols&gt;&lt;BestFitRows&gt;False&lt;/BestFitRows&gt;&lt;PageStart&gt;-1&lt;/PageStart&gt;&lt;PageEnd&gt;-1&lt;/PageEnd&gt;&lt;ColStart&gt;-1&lt;/ColStart&gt;&lt;ColEnd&gt;-1&lt;/ColEnd&gt;&lt;RowStart&gt;-1&lt;/RowStart&gt;&lt;RowEnd&gt;-1&lt;/RowEnd&gt;&lt;ShowBorder&gt;True&lt;/ShowBorder&gt;&lt;ShowGrid&gt;True&lt;/ShowGrid&gt;&lt;ShowColor&gt;False&lt;/ShowColor&gt;&lt;ShowColumnHeader&gt;Inherit&lt;/ShowColumnHeader&gt;&lt;ShowRowHeader&gt;Inherit&lt;/ShowRowHeader&gt;&lt;ShowFilterBar&gt;Inherit&lt;/ShowFilterBar&gt;&lt;ShowColumnFooter&gt;Inherit&lt;/ShowColumnFooter&gt;&lt;ShowColumnFooterEachPage&gt;True&lt;/ShowColumnFooterEachPage&gt;&lt;ShowTitle&gt;True&lt;/ShowTitle&gt;&lt;ShowSubtitle&gt;True&lt;/ShowSubtitle&gt;&lt;UseMax&gt;True&lt;/UseMax&gt;&lt;UseSmartPrint&gt;False&lt;/UseSmartPrint&gt;&lt;Opacity&gt;255&lt;/Opacity&gt;&lt;PrintNotes&gt;None&lt;/PrintNotes&gt;&lt;Centering&gt;None&lt;/Centering&gt;&lt;RepeatColStart&gt;-1&lt;/RepeatColStart&gt;&lt;RepeatColEnd&gt;-1&lt;/RepeatColEnd&gt;&lt;RepeatRowStart&gt;-1&lt;/RepeatRowStart&gt;&lt;RepeatRowEnd&gt;-1&lt;/RepeatRowEnd&gt;&lt;SmartPrintPagesTall&gt;1&lt;/SmartPrintPagesTall&gt;&lt;SmartPrintPagesWide&gt;1&lt;/SmartPrintPagesWide&gt;&lt;HeaderHeight&gt;-1&lt;/HeaderHeight&gt;&lt;FooterHeight&gt;-1&lt;/FooterHeight&gt;&lt;/PrintInfo&gt;&lt;TitleInfo class=&quot;FarPoint.Web.Spread.TitleInfo&quot;&gt;&lt;Style class=&quot;FarPoint.Web.Spread.StyleInfo&quot;&gt;&lt;BackColor&gt;#e7eff7&lt;/BackColor&gt;&lt;CellType class=&quot;FarPoint.Web.Spread.TextCellType&quot;&gt;&lt;ErrorMsg&gt;The maximum text lengh is {0}&lt;/ErrorMsg&gt;&lt;TextCellType /&gt;&lt;/CellType&gt;&lt;HorizontalAlign&gt;Right&lt;/HorizontalAlign&gt;&lt;/Style&gt;&lt;/TitleInfo&gt;&lt;WorksheetTemplate class=&quot;FarPoint.Web.Spread.WorksheetTemplate&quot;&gt;&lt;Layout&gt;&lt;ColumnCount&gt;4&lt;/ColumnCount&gt;&lt;/Layout&gt;&lt;AxisModels&gt;&lt;LayoutColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Horizontal&quot; count=&quot;4&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/LayoutColumn&gt;&lt;/AxisModels&gt;&lt;Data&gt;&lt;LayoutData class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;4&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;Cells&gt;&lt;Cell row=&quot;0&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;0&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;2&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;3&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/LayoutData&gt;&lt;/Data&gt;&lt;/WorksheetTemplate&gt;&lt;LayoutMode&gt;CellLayoutMode&lt;/LayoutMode&gt;&lt;AutoFilterMode&gt;FilterGadget&lt;/AutoFilterMode&gt;&lt;CurrentPageIndex type=&quot;System.Int32&quot;&gt;0&lt;/CurrentPageIndex&gt;&lt;/Settings&gt;&lt;/Sheet&gt;" 
              EnableRowEditTemplate="True" GridLineColor="208, 215, 229" 
              SelectionBackColor="234, 236, 245">
          <RowEditTemplate>
            <table cellpadding="0" cellspacing="1" style="background-color: black">
              <tr>
                <td colspan="2" style="vertical-align: middle; background-color: khaki; text-align: center">Book Information Management</td>
              </tr>
              <tr>
                <td style="width: 100px; background-color: lemonchiffon">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement1" runat="server"
                    Height="20px" ReplacementType="Header" Width="100" />
                </td>
                <td style="width: 200px; background-color: white">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement2" runat="server"
                    Height="20px" Width="95%" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" />
                </td>
              </tr>
              <tr>
                <td style="width: 100px; background-color: lemonchiffon">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement3" runat="server"
                    ColumnIndex="1" Height="20px" ReplacementType="Header" Width="100" />
                </td>
                <td style="width: 200px; background-color: white">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement7" runat="server"
                    ColumnIndex="1" Height="20px" Width="95%" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" />
                </td>
              </tr>
              <tr>
                <td style="width: 100px; background-color: lemonchiffon">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement4" runat="server"
                    ColumnIndex="2" Height="20px" ReplacementType="Header" Width="100" />
                </td>
                <td style="width: 200px; background-color: white">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement8" runat="server"
                    ColumnIndex="2" Height="20px" Width="95%" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" />
                </td>
              </tr>
              <tr>
                <td style="width: 100px; background-color: lemonchiffon">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement5" runat="server"
                    ColumnIndex="3" Height="20px" ReplacementType="Header" Width="100" />
                </td>
                <td style="width: 200px; background-color: white">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement9" runat="server"
                    ColumnIndex="3" Height="20px" Width="95%" />
                </td>
              </tr>
              <tr>
                <td style="width: 100px; background-color: lemonchiffon">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement6" runat="server"
                    ColumnIndex="4" Height="20px" ReplacementType="Header" Width="100" />
                </td>
                <td style="width: 200px; background-color: white">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement10" runat="server"
                    ColumnIndex="4" Height="20px" Width="95%" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" />
                </td>
              </tr>
              <tr>
                <td style="width: 100px; background-color: lemonchiffon"></td>
                <td style="width: 200px; background-color: white; text-align: right">
                  <FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement11" runat="server"
                    Height="20" ReplacementType="UpdateButton" Width="50px" />
                  &nbsp;<FarPoint:FpSpreadTemplateReplacement ID="FpSpreadTemplateReplacement12"
                    runat="server" Height="20" ReplacementType="CancelButton" Width="50px" />
                  &nbsp;&nbsp;
                </td>
              </tr>
            </table>
            <br />
          </RowEditTemplate>
        </FarPoint:SheetView>
      </Sheets>
      <TitleInfo BackColor="231, 239, 247" CellTypeDesignString="&lt;CellType class=&quot;FarPoint.Web.Spread.TextCellType&quot;&gt;&lt;TextCellType /&gt;&lt;/CellType&gt;"
        Font-Size="X-Large" Height="" HorizontalAlign="Center" Font-Bold="False" 
            Font-Italic="False" Font-Overline="False" Font-Strikeout="False" 
            Font-Underline="False">
      </TitleInfo>
    </FarPoint:FpSpread>
  </div>
</asp:Content>

<asp:Content ID="Content3" ContentPlaceHolderID="Description" runat="server">
    <p>
      您可以允许用户使用特定模板或 Form 编辑行。在本示例中，可以双击单元格，这时行数据会显示在一个 Form 中，您可以在编辑数据后点击 Update 或 Cancel 按钮执行或取消操作。
    </p>
</asp:Content>

<asp:Content ID="Content4" ContentPlaceHolderID="ControlOptions" runat="server">
</asp:Content>
